.. _`Replace values in Tables with Table`:

.. _`org.sysess.sympathy.data.table.tablesvaluesearchreplacewithtable`:

Replace values in Tables with Table
```````````````````````````````````

.. image:: search_replace.svg
   :width: 48


Search and replace values in specified columns table with search expressions from a table




Documentation
:::::::::::::

Auto generated list version of :ref:`Replace values in Table with Table`.

In this version, the following ports from the original nodes have been
changed to lists which the node loops over:

    :Looped Inputs: data.
    :Looped Outputs: data.

For details see the original node.


Definition
::::::::::


Input ports
...........

    **expressions**  table
        Expressions

    **data**  [table]
        Table Data


Output ports
............

    **data**  [table]
        Table with replaced values




Configuration
.............

    **Columns to replace values in** (column)
        Select in which to perform replace
    **Column with search expressions** (find)
        Select which column contains search expressions
    **Ignore case** (ignore_case)
        Ignore case when searching
    **Text replace only (using regex)** (literal)
        Perform regex replacements in string columns, i.e., columns with types text and bytes, other columns are ignored. Disable this option to replace full values, without using regex across all types of columns. Learn more about Regular expression syntax in the documentation appendix.
    **Column with replace expressions** (replace)
        Select which column contains replacements





Related nodes
.............

* :ref:`org.sysess.sympathy.data.table.tablevaluesearchreplacewithtable`






Implementation
..............

.. automodule:: node_table_value_search_replace
    :noindex:

.. class:: TableValueSearchReplaceWithTableMultiple
    :noindex: